﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SSABSZ.SuperEP.Core;

namespace SSABSZ.SuperEP.Data
{
    public class HVCData
    {
        public List<dtoEPKey> GetRootKeys()
        {
            var ret = new List<dtoEPKey>();
            var listHVCEnvProfiles = from tabHVCEnvProfiles in DataLayerManager.SCMLINQConnection.tabHVCEnvProfiles
                                     where tabHVCEnvProfiles.ParentGUID==0
                                     orderby tabHVCEnvProfiles.DisplaySequence ascending
                                     select tabHVCEnvProfiles;

            foreach (var prof in listHVCEnvProfiles)
            {
                var dto = new dtoEPKey();
                dto.Name = prof.Code;
                ret.Add(dto);
            }

            return ret;
        }

    }
}
